/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost
 Source Database       : shop

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : utf-8

 Date: 11/01/2017 15:39:45 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `achievement`
-- ----------------------------
DROP TABLE IF EXISTS `achievement`;
CREATE TABLE `achievement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `achievement`
-- ----------------------------
BEGIN;
INSERT INTO `achievement` VALUES ('1', 'a', '1', '89'), ('2', 'a', '2', '95'), ('3', 'b', '2', '92'), ('4', 'b', '4', '91'), ('5', 'c', '1', '75'), ('6', 'c', '2', '47'), ('7', 'c', '3', '99');
COMMIT;

-- ----------------------------
--  Table structure for `good`
-- ----------------------------
DROP TABLE IF EXISTS `good`;
CREATE TABLE `good` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `sell` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('1', '商品列表', 'good', 'fa fa-book'), ('2', '用户列表', 'user', 'fa fa-book'), ('3', '店铺管理', 'shop', 'fa fa-book'), ('4', '购物车', 'shopcar', 'fa fa-shopping-cart'), ('5', '我的设置', 'configuration', 'fa fa-cog');
COMMIT;

-- ----------------------------
--  Table structure for `user_info`
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `code` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `likes` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `user_info`
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES ('1', '陆浩波', 'xiaobai', '123456', '上海-上海市-徐汇区', null, '17', '篮球,足球,乒乓球,棒球'), ('2', '小明', 'code2', '123456', '江苏省-无锡市-锡山区', null, '17', '足球,乒乓球'), ('3', '小红', 'code3', '123456', '北京-北京市-海淀区', null, '18', '足球,乒乓球'), ('4', '小刚', 'code', null, null, null, '13', ''), ('5', '小顾', 'code', null, null, null, '25', ''), ('6', '小金', 'code', null, null, null, '14', '足球,乒乓球'), ('7', 'xiaoming5', 'code', null, null, null, '67', null), ('8', 'xiaoming6', 'code', null, null, null, '23', null), ('9', 'xiaoming7', 'code', null, null, null, '23', null), ('10', 'xiaoming8', 'code', null, null, null, '25', null), ('11', 'xiaoming9', 'code', null, null, null, '26', null), ('12', 'xiaoming10', 'code', null, null, null, '27', null), ('13', 'xiaoming11', 'code', null, null, null, '28', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
